SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerAreasTematicasSP]
-- < Registro de Actualizaciones >
-- 24-10-2006 
-- 16-11-2006
	@IdSubProyecto INT

AS
SET NOCOUNT ON
SET DATEFORMAT DMY
SELECT A.IdAreaTematica AS ID, A.Descripcion +' - '+M.Mnemo as Descripcion
	FROM tb_AreasTematicas  A
	INNER JOIN tb_RelAreasTematicasSP ASP ON ASP.IdAreaTematica=A.IdAreaTematica AND ASP.IdSubProyecto=@IdSubProyecto
	INNER JOIN tb_MacroAreasTematicas M ON M.IdMacroAreaTematica= A.MacroAreaTematica
	ORDER BY Descripcion
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerAreasTematicasSP] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerAreasTematicasSP] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerAreasTematicasSP] TO [SoloVer]
GO
